Data Science with SQL Server Quick Start Guide by Dejan Sarka

Author:Dejan Sarka
Language: eng
Format: epub
Tags: COM062000 - COMPUTERS / Data Modeling and Design, COM018000 - COMPUTERS / Data Processing, COM021030 - COMPUTERS / Databases / Data Mining
Publisher: Packt Publishing
Published: 2018-08-31T07:43:39+00:00

con = pyodbc.connect('DSN=AWDW;UID=RUser;PWD=Pa$$w0rd')

query = """SELECT CustomerKey,

TotalChildren, NumberChildrenAtHome,

Gender, HouseOwnerFlag,

NumberCarsOwned, MaritalStatus,

Age, YearlyIncome, BikeBuyer,

EnglishEducation AS Education,

EnglishOccupation AS Occupation

FROM dbo.vTargetMail"""

TM = pd.read_sql(query, con)

You already know that you can create graphs with pandas. In the previous code, you can see that I imported some libraries I did not describe yet. Let me introduce them.

You will learn how to do graphs with two Python libraries: matplotlib and seaborn. Both of them are included in the Python version shipped with SQL Server ML Services (In-database). Matplotlib is a cross-platform graphics engine, used as a backbone for many other graphical functions from other libraries. Besides importing this library, you need also to import an interface to it.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.